Computer Science for IGCSE & O level - Databases (Section 3 - No. 39)

What is the function of an aggregate function in SQL (e.g., `SUM`, `AVG`)?

To filter data based on specific criteria.

To perform calculations on a set of values.

To combine data from multiple tables.

To sort the data in ascending or descending order.

Aggregate functions perform calculations (like sum, average, count) on a set of values, returning a single result.